UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hs5NXzXEbFY4m/e0ikIYrpkfe48Cn2OowB6RQaaRKGM='
WHERE
key_id = 'fd7680921762b2941a44853897b7c7fc6c0a5d31de8aa9d35fd0194ad3fb1355'
AND (
token = 'Hs5NXzXEbFY4m/e0ikIYrpkfe48Cn2OowB6RQaaRKGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)