UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Vz7MkIA4j7arCitOTe270gp1RdfhcmjOxeRTnjEhCs='
WHERE
key_id = 'bb8d38d9bc19247ad421b8aebb19c257c757d780b2ac5a188f50f434914b52bc'
AND (
token = '1Vz7MkIA4j7arCitOTe270gp1RdfhcmjOxeRTnjEhCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)