UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BD9eQ+89jBmAzaRkGsrd118I4MHjsEkxZdjf7M0RD8='
WHERE
key_id = '1249ac2f0c5b7b871ef94d26d86beffe3e2d247a57987ae96d28e376ac29810b'
AND (
token = '8BD9eQ+89jBmAzaRkGsrd118I4MHjsEkxZdjf7M0RD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)