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