UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asDsC+YNYHvyWKgTWj+Ufv9cI3H4PVNG9e/tzJHcNpw='
WHERE
key_id = '423bc79406d17e029d6daa56b61dd5f9896ac0700bc18ec98d74802cfd6ed2d5'
AND (
token = 'asDsC+YNYHvyWKgTWj+Ufv9cI3H4PVNG9e/tzJHcNpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)