UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Jy0N6I8dMRf4AXcj3NzK5AtTa/wg00imA9AhejBHWE='
WHERE
key_id = '4777f9873055358ec23c38edda3db5fd58509c2be5791a28d61772b3fdbac742'
AND (
token = '5Jy0N6I8dMRf4AXcj3NzK5AtTa/wg00imA9AhejBHWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)