UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAxtXQWNOapNRhP55NHBFYxj90Mq4hb5WObk5WhAhSw='
WHERE
key_id = '8c01e0a0aeb03505707a32341bf24a2de32fb2b2af5e910a3abe2913cb18e585'
AND (
token = 'xAxtXQWNOapNRhP55NHBFYxj90Mq4hb5WObk5WhAhSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)