UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TR9vC96QnBXSMAXqKw3H41bOzLaBm7ebvjBT62gUbF4='
WHERE
key_id = 'f25b72d3aebb22b857b7d7ad8baa5d545ebd86d388bce387d81404debbdd6861'
AND (
token = 'TR9vC96QnBXSMAXqKw3H41bOzLaBm7ebvjBT62gUbF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)