UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Zvhg05UnzxQhCpRvEUl/85fFJG4CpnfxnPh9sWPXpo='
WHERE
key_id = '1adb24b82a4b0a02841b73abf69a78c6a0d683a8c2a3925f384edf19ee29bfe6'
AND (
token = '9Zvhg05UnzxQhCpRvEUl/85fFJG4CpnfxnPh9sWPXpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)