UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9p3aJgnzN8Z+OBglVnskX3Vvistb8V7kHtpGNsn/R+w='
WHERE
key_id = '304a7e41176efb14d11b1889a3072c99546247efe0fae85e9763f0978d75f088'
AND (
token = '9p3aJgnzN8Z+OBglVnskX3Vvistb8V7kHtpGNsn/R+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)