UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bnoGs4xOq7e41aQC417uO1vBrmcItNLs00Fm8dn1yEk='
WHERE
key_id = '16ca25fd8af751d248a8c367805a5f9a926a77711db87bf2bf7c8a2dfdbb3af3'
AND (
token = 'bnoGs4xOq7e41aQC417uO1vBrmcItNLs00Fm8dn1yEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)