UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6s5EkdBAoybuOEwR9G+2KFtrU01Ubpa4aobwgRNtjnY='
WHERE
key_id = '7b73424c04be6907e0a87b2439beea2276e27dcd5d86d8742ab87f1e02cca30b'
AND (
token = '6s5EkdBAoybuOEwR9G+2KFtrU01Ubpa4aobwgRNtjnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)