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