UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPI6Rvzg8/njmfM93Vogy8FJuvX/ToH4bXVajy44GIs='
WHERE
key_id = 'e44e3da3c5c9b3d59f047cafc2f3bcab1a5f130c6e64c2ebb188a07bdc844640'
AND (
token = 'nPI6Rvzg8/njmfM93Vogy8FJuvX/ToH4bXVajy44GIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)