UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04a6ZmkDnqblNHajQqfc9nJzClhUB9P475ZLx9qhCJs='
WHERE
key_id = '216516b03825e146fb80c9e2e4410facf493cac690e56f20ee1a8b0f9ffb0ca5'
AND (
token = '04a6ZmkDnqblNHajQqfc9nJzClhUB9P475ZLx9qhCJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)