UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z78yC2xded+eIwtZ5g1pKIor4CAdJjGVCezKOKUlx2k='
WHERE
key_id = 'f598149fa60e013ba41ec03bfd1969a897bfa0136805b6a67661b75a398fe546'
AND (
token = 'Z78yC2xded+eIwtZ5g1pKIor4CAdJjGVCezKOKUlx2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)