UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwabWY7pOyno4aG8gAKNchi4OMia5fl4DIQ4xx38AJM='
WHERE
key_id = '578887ec45fa2c9d8d17b59f515d5eb61c7b5ef0270fa83d2288abc866e66a71'
AND (
token = 'XwabWY7pOyno4aG8gAKNchi4OMia5fl4DIQ4xx38AJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)