UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnpzT43L2+MmPWQs4SuWsxXJw0M2k+7mVifd4PVMzkg='
WHERE
key_id = '5d827fe903b3547a0d8a52d0821d5fa3d1bfbe8fad78fba4c548e0c05dd08c3c'
AND (
token = 'ZnpzT43L2+MmPWQs4SuWsxXJw0M2k+7mVifd4PVMzkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)