UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SjM3XEPcVpOSuet2ZEIIH4Zk/OVhyI4VDdWq1zfEoWY='
WHERE
key_id = '2f1e7efde0500e477471b84d286a7a792955276c492fde2f6b3a7b0a64d0d953'
AND (
token = 'SjM3XEPcVpOSuet2ZEIIH4Zk/OVhyI4VDdWq1zfEoWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)