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