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