UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xw+7IvV7k8NvSeqviyXW+7tSvfBRf2F8OcP0KhygSYY='
WHERE
key_id = 'aa750935acc94bec26a75b4ae3822ee64ef8635a9b562e5b1ff9f85f2b17def0'
AND (
token = 'xw+7IvV7k8NvSeqviyXW+7tSvfBRf2F8OcP0KhygSYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)