UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nb0T7mIWDV107jLgA6QDsvzxQ9GDllw4GcRcBbQ5Ym0='
WHERE
key_id = '954ee274150115641c88578f27868aa23129d18917a57b54dccb8504ac5c2999'
AND (
token = 'Nb0T7mIWDV107jLgA6QDsvzxQ9GDllw4GcRcBbQ5Ym0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)