UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sfn0qeIln+Eqwo94wW13a3T1WKzQCmdf2RNJNMscdok='
WHERE
key_id = '0f204754093f4e7330b16c181178a7a3b559210348566fb88b0f309ecb1610b4'
AND (
token = 'Sfn0qeIln+Eqwo94wW13a3T1WKzQCmdf2RNJNMscdok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)