UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqXLOtwHBdPAozOqWLFpwtcq1EypBnN2TeAxDTKrdJs='
WHERE
key_id = '6840573bdba7785bb569b499cdee1334782acfa710033ae3cb77e98d922b0893'
AND (
token = 'BqXLOtwHBdPAozOqWLFpwtcq1EypBnN2TeAxDTKrdJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)