UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R6Q1p+FNXoA7lQj9fpMO7Jxld039bKwX4iKYNmjipcc='
WHERE
key_id = '4180e664d425e7ac225ceaa1c6a41f90f0195e1de0fce92f49377f5a7b11a1c7'
AND (
token = 'R6Q1p+FNXoA7lQj9fpMO7Jxld039bKwX4iKYNmjipcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)