UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHROoCZfqHZa6IHV8EiDRer1KtrxxKST7m23p+KrYj8='
WHERE
key_id = 'a5ff05db3b58b605ca9d6be6262c9a6235eb244a0d34703bf40e56edb1f14cd2'
AND (
token = 'NHROoCZfqHZa6IHV8EiDRer1KtrxxKST7m23p+KrYj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)