UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tA4G8beWX13p7VouXOVcUbQZjrDB4Xdzw2eALLF2a3g='
WHERE
key_id = 'fa575a2403dbe4ccf8cac202a9e622e025725a432a0c67fa4886a10f8cd7e72e'
AND (
token = 'tA4G8beWX13p7VouXOVcUbQZjrDB4Xdzw2eALLF2a3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)