UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b4iWjOvqLss+tXPFZyPUyc5hqeHZOAM36ubTpbI7nLI='
WHERE
key_id = 'e13f353d14f8410e61ad03848c4a265816decfb591d2777fe8150f5331d075c2'
AND (
token = 'b4iWjOvqLss+tXPFZyPUyc5hqeHZOAM36ubTpbI7nLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)