UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sAr8h8EPVloX2ASaN+ozIY3I+JgJahm4S5Z3a1uU7UA='
WHERE
key_id = 'b9e45f6eb9697c755e3fd86406cf2e75d92e1cbaed0dd6a5a9d5edcba9a3a799'
AND (
token = 'sAr8h8EPVloX2ASaN+ozIY3I+JgJahm4S5Z3a1uU7UA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)