UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKnqw+07ycBAsW46jPcutdUnpMHYnZomUyV7UWD59Wc='
WHERE
key_id = 'b631d53a2415e4cedafa71a9b0fc65d5b356141d152eab421c0eaa002c8b71c7'
AND (
token = 'cKnqw+07ycBAsW46jPcutdUnpMHYnZomUyV7UWD59Wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)