UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ek7Jyj5b2XfedHew47U1NFEg0J+/2aPUcKYVA4m7iRQ='
WHERE
key_id = 'dcfb847aee5f515a9977d3de32e2d0b736fe06cb57795a623a6e5051c904046e'
AND (
token = 'ek7Jyj5b2XfedHew47U1NFEg0J+/2aPUcKYVA4m7iRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)